In this module, you help
Little Lemon to perform advanced data
analytics to generate data insights to inform
their business decisions. You also help them to create a database client that
they could use to interact with their database using a Python-based
application. Let's take a few minutes
to recap the tasks, processes, and tools that
you used in this module. In the first lesson, you used Tableau to
help Little Lemon generate insights using the
tools data analysis features. Tableau is a widely used
data visualization tool. There were several key
features and offers that you were able to take advantage
of when analyzing data. For example, with Tableau, you were able to connect to a
wide range of data sources, process large amounts of
different data types, and create visualized
data charts. You were also able to generate real-time
interactive dashboards, script in Python and R, and complete tasks using
interactive UI tools. You were also able
to make use of the dashboard interfaces
features to analyze data. You connected your
data sources to Tableau using the Connect
pane in the launch page. Once you connected
to your data source, you then used the
authoring workspaces, UI elements to create
a visualization of your data using worksheets,
dashboards, and story. You also used the worksheets to add data to your view using the marks card and analyze and visualize data using the
row and column shelves. You then prepared your
data for analysis using process steps like splitting data for greater accessibility, creating calculated data fields, fixing datatypes,
and filtering data. With Tableau, you also
focused on relevant data using the software's filtering and visualization features, so you could focus only
on the data you need. You also used the
drill-down, roll-up, and other filtering features
to show the data from different perspectives or in
different levels of detail. You also used Tableau to produce interactive real-time
data visualizations in the form of dashboards. Your well-organized
dashboards helped to provide clear views and relevant answers to Little Lemon's important
business questions. In the next lesson, you
helped Little Lemon to create a database client so that they could interact
with their database using a Python-based
application. You first identified
which version of Python was running on your machine
using the command prompt. Once you confirmed that the correct version of Python
was correctly installed, you checked which iteration
of Python 3 you were running, and you checked that it matched the most recent iteration on
the official Python website. Once you confirmed that
you were running Python, you then chose an IDE or integrated
development environment to run your code on. In this course, you use the Jupiter IDE to
demonstrate Python. You followed the Jupiter
installation process and then typed
Jupyter Notebook to open a new instance of the Jupyter Notebook to use
within your default browser. You then connected python to the Little Lemon MySQL database. You created the
installation using a purpose-built Python library
called MySQL Connector. You were able to do this using
the Pip software package. Then you checked that your
environment was correctly configured to ensure that the library was
imported successfully. Once you set up your
Python environment, you were able to begin working
with your database client. You completed an exercise in which you added
or implemented query functions using Python to query the Little
Lemon database. Finally, you committed
your progress to Git. You have helped Little Lemon to perform advanced data analytics, degenerate data insights to inform their business decisions, and you have also helped them to create a database
client that they can use to interact
with their database using a Python-based
application. Well done, I look
forward to providing you with more guidance
in the next module.